Mega Code Archive
Date Timezone
1) Comparing date in where clause
2) Date_part(year, date)
3) Date_trunc(hour, now())
4) Date_trunc(minute, now())
5) Date_trunc(year, now())
6) Displays the current date formatting style
7) Extract(MONTH FROM now())
8) Get current date
9) Get current time
10) Get current time for logging
11) Get time of day
12) Interpreting interval formats
13) Now()
14) Return the current time using the ISO format as instructed
15) SELECT now()
16) SET DATESTYLE TO NONEUROPEAN, GERMAN
17) Sets the date and time formatting to ISO
18) Sets the DATESTYLE variable to use traditional PostgreSQL style formatting
19) Setting date formats
20) To_char(now(), Dy (Day), Mon (Month))
21) To_char(now(), HH
22) To_char(start_date, FMMonth FMDDth, YYYY)
23) To_char(start_date, Y,YYY years A D )
24) To_char(start_date, YYYY-MM-DD HH24
25) To_char(start_date, YYYY-MM-DD)
26) To_char(yesterday
27) To_date(198025thJune, YYYYDDthMonth)
28) To_timestamp(197825July01
29) Using timestamp values correctly